USE [genshi]
GO

/****** Object:  Table [dbo].[Assemble]    Script Date: 2022/5/3 20:26:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Assemble](
	[Name] [nvarchar](10) NOT NULL,
	[Weapon] [nvarchar](10) NULL,
	[Flower] [smallint] NULL,
	[Feather] [smallint] NULL,
	[Sand] [smallint] NULL,
	[Cup] [smallint] NULL,
	[Head] [smallint] NULL,
	[Life] [int] NULL,
	[Attack] [smallint] NULL,
	[Defense] [smallint] NULL,
	[Mystery] [smallint] NULL,
	[Criticalhit] [real] NULL,
	[Criticaldamage] [real] NULL,
	[Treatment] [real] NULL,
	[Efficiency] [real] NULL,
	[Fire] [real] NULL,
	[Water] [real] NULL,
	[Thunder] [real] NULL,
	[Wind] [real] NULL,
	[Ice] [real] NULL,
	[Rock] [real] NULL,
	[Physics] [real] NULL,
	[IncreaseLife] [smallint] NULL,
	[IncreaseAttack] [smallint] NULL,
	[IncreaseDefense] [smallint] NULL,
	[LifePercentage] [real] NULL,
	[AttackPercentage] [real] NULL,
	[DefensePercentage] [real] NULL,
PRIMARY KEY CLUSTERED 
(
	[Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Life]  DEFAULT ((0)) FOR [Life]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Attack]  DEFAULT ((0)) FOR [Attack]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Defense]  DEFAULT ((0)) FOR [Defense]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Mystery]  DEFAULT ((0)) FOR [Mystery]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Criticalhit]  DEFAULT ((0.05)) FOR [Criticalhit]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Criticaldamage]  DEFAULT ((0.5)) FOR [Criticaldamage]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Treatment]  DEFAULT ((0)) FOR [Treatment]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Efficiency]  DEFAULT ((1)) FOR [Efficiency]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Fire]  DEFAULT ((0)) FOR [Fire]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Water]  DEFAULT ((0)) FOR [Water]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Thunder]  DEFAULT ((0)) FOR [Thunder]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Wind]  DEFAULT ((0)) FOR [Wind]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Ice]  DEFAULT ((0)) FOR [Ice]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Rock]  DEFAULT ((0)) FOR [Rock]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_Physics]  DEFAULT ((0)) FOR [Physics]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_IncreaseLife]  DEFAULT ((0)) FOR [IncreaseLife]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_IncreaseAttack]  DEFAULT ((0)) FOR [IncreaseAttack]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_IncreaseDefense]  DEFAULT ((0)) FOR [IncreaseDefense]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_LifePercentage]  DEFAULT ((0)) FOR [LifePercentage]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_AttackPercentage]  DEFAULT ((0)) FOR [AttackPercentage]
GO

ALTER TABLE [dbo].[Assemble] ADD  CONSTRAINT [DF_Assemble_DefensePercentage]  DEFAULT ((0)) FOR [DefensePercentage]
GO

ALTER TABLE [dbo].[Assemble]  WITH CHECK ADD  CONSTRAINT [FK_Assemble_Character] FOREIGN KEY([Name])
REFERENCES [dbo].[Character] ([Name])
GO

ALTER TABLE [dbo].[Assemble] CHECK CONSTRAINT [FK_Assemble_Character]
GO

ALTER TABLE [dbo].[Assemble]  WITH CHECK ADD  CONSTRAINT [FK_Assemble_Relics_Cup] FOREIGN KEY([Cup])
REFERENCES [dbo].[Relics] ([id])
GO

ALTER TABLE [dbo].[Assemble] CHECK CONSTRAINT [FK_Assemble_Relics_Cup]
GO

ALTER TABLE [dbo].[Assemble]  WITH CHECK ADD  CONSTRAINT [FK_Assemble_Relics_Feather] FOREIGN KEY([Feather])
REFERENCES [dbo].[Relics] ([id])
GO

ALTER TABLE [dbo].[Assemble] CHECK CONSTRAINT [FK_Assemble_Relics_Feather]
GO

ALTER TABLE [dbo].[Assemble]  WITH CHECK ADD  CONSTRAINT [FK_Assemble_Relics_Flower] FOREIGN KEY([Flower])
REFERENCES [dbo].[Relics] ([id])
GO

ALTER TABLE [dbo].[Assemble] CHECK CONSTRAINT [FK_Assemble_Relics_Flower]
GO

ALTER TABLE [dbo].[Assemble]  WITH CHECK ADD  CONSTRAINT [FK_Assemble_Relics_Head] FOREIGN KEY([Head])
REFERENCES [dbo].[Relics] ([id])
GO

ALTER TABLE [dbo].[Assemble] CHECK CONSTRAINT [FK_Assemble_Relics_Head]
GO

ALTER TABLE [dbo].[Assemble]  WITH CHECK ADD  CONSTRAINT [FK_Assemble_Relics_Sand] FOREIGN KEY([Sand])
REFERENCES [dbo].[Relics] ([id])
GO

ALTER TABLE [dbo].[Assemble] CHECK CONSTRAINT [FK_Assemble_Relics_Sand]
GO

ALTER TABLE [dbo].[Assemble]  WITH CHECK ADD  CONSTRAINT [FK_Assemble_Weapon] FOREIGN KEY([Weapon])
REFERENCES [dbo].[Weapon] ([Name])
GO

ALTER TABLE [dbo].[Assemble] CHECK CONSTRAINT [FK_Assemble_Weapon]
GO

